-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 03-08-2012 a las 23:02:31
-- Versión del servidor: 5.5.16
-- Versión de PHP: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de datos: `bonpland`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `depto`
--

CREATE TABLE IF NOT EXISTS `depto` (
  `idDepto` int(11) NOT NULL AUTO_INCREMENT,
  `Piso` int(2) NOT NULL,
  `depto` varchar(1) NOT NULL,
  `idDeptoTarjeta` int(11) NOT NULL,
  `NombreTitular` varchar(250) NOT NULL,
  PRIMARY KEY (`idDepto`),
  KEY `idDeptoTarjeta` (`idDeptoTarjeta`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;

--
-- Volcado de datos para la tabla `depto`
--

INSERT INTO `depto` (`idDepto`, `Piso`, `depto`, `idDeptoTarjeta`, `NombreTitular`) VALUES
(1, 1, 'A', 1, ''),
(2, 1, 'B', 2, ''),
(3, 1, 'C', 3, ''),
(4, 1, 'D', 4, ''),
(5, 1, 'E', 5, ''),
(6, 2, 'A', 6, ''),
(7, 2, 'B', 7, ''),
(8, 2, 'C', 8, ''),
(9, 2, 'D', 9, ''),
(10, 2, 'E', 10, ''),
(11, 3, 'A', 11, ''),
(12, 3, 'B', 12, ''),
(13, 3, 'C', 13, ''),
(14, 3, 'D', 14, ''),
(15, 3, 'E', 15, ''),
(16, 4, 'A', 16, ''),
(17, 4, 'B', 17, ''),
(18, 4, 'C', 18, ''),
(19, 4, 'D', 19, ''),
(20, 4, 'E', 20, ''),
(21, 5, 'A', 21, ''),
(22, 5, 'B', 22, ''),
(23, 5, 'C', 23, ''),
(24, 5, 'D', 24, ''),
(25, 5, 'E', 25, ''),
(26, 6, 'A', 26, ''),
(27, 6, 'B', 27, ''),
(28, 6, 'C', 28, ''),
(29, 6, 'D', 29, ''),
(30, 6, 'E', 30, ''),
(31, 7, 'A', 31, ''),
(32, 7, 'B', 32, ''),
(33, 7, 'C', 33, ''),
(34, 7, 'D', 34, ''),
(35, 7, 'E', 35, ''),
(36, 8, 'A', 36, ''),
(37, 8, 'B', 37, ''),
(38, 8, 'C', 38, ''),
(39, 8, 'D', 39, ''),
(40, 8, 'E', 40, ''),
(41, 9, 'A', 41, ''),
(42, 9, 'B', 42, ''),
(43, 9, 'C', 43, ''),
(44, 9, 'D', 44, ''),
(45, 9, 'E', 45, ''),
(46, 10, 'A', 46, ''),
(47, 10, 'B', 47, ''),
(48, 10, 'C', 48, ''),
(49, 10, 'D', 49, ''),
(50, 10, 'E', 50, ''),
(51, 11, 'A', 51, ''),
(52, 11, 'B', 52, ''),
(53, 11, 'C', 53, ''),
(54, 11, 'D', 54, ''),
(55, 11, 'E', 55, ''),
(56, 12, 'A', 56, ''),
(57, 12, 'B', 57, ''),
(58, 12, 'C', 58, ''),
(59, 12, 'D', 59, ''),
(60, 12, 'E', 60, ''),
(61, 13, 'A', 61, ''),
(62, 13, 'B', 62, ''),
(63, 13, 'C', 63, ''),
(64, 13, 'D', 64, ''),
(65, 13, 'E', 65, ''),
(66, 14, 'A', 66, ''),
(67, 14, 'B', 67, ''),
(68, 14, 'C', 68, ''),
(69, 14, 'D', 69, ''),
(70, 14, 'E', 70, '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `depto_tarjeta`
--

CREATE TABLE IF NOT EXISTS `depto_tarjeta` (
  `idDeptoTarjeta` int(11) NOT NULL AUTO_INCREMENT,
  `idTarjeta` int(11) NOT NULL,
  `idDepto` int(11) NOT NULL,
  PRIMARY KEY (`idDeptoTarjeta`),
  KEY `idTarjeta` (`idTarjeta`,`idDepto`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=701 ;

--
-- Volcado de datos para la tabla `depto_tarjeta`
--

INSERT INTO `depto_tarjeta` (`idDeptoTarjeta`, `idTarjeta`, `idDepto`) VALUES
(1, 1, 1),
(2, 2, 1),
(3, 3, 1),
(4, 4, 1),
(5, 5, 1),
(6, 6, 1),
(7, 7, 1),
(8, 8, 1),
(9, 9, 1),
(10, 10, 1),
(11, 11, 2),
(12, 12, 2),
(13, 13, 2),
(14, 14, 2),
(15, 15, 2),
(16, 16, 2),
(17, 17, 2),
(18, 18, 2),
(19, 19, 2),
(20, 20, 2),
(21, 21, 3),
(22, 22, 3),
(23, 23, 3),
(24, 24, 3),
(25, 25, 3),
(26, 26, 3),
(27, 27, 3),
(28, 28, 3),
(29, 29, 3),
(30, 30, 3),
(31, 31, 4),
(32, 32, 4),
(33, 33, 4),
(34, 34, 4),
(35, 35, 4),
(36, 36, 4),
(37, 37, 4),
(38, 38, 4),
(39, 39, 4),
(40, 40, 4),
(41, 41, 5),
(42, 42, 5),
(43, 43, 5),
(44, 44, 5),
(45, 45, 5),
(46, 46, 5),
(47, 47, 5),
(48, 48, 5),
(49, 49, 5),
(50, 50, 5),
(51, 51, 6),
(52, 52, 6),
(53, 53, 6),
(54, 54, 6),
(55, 55, 6),
(56, 56, 6),
(57, 57, 6),
(58, 58, 6),
(59, 59, 6),
(60, 60, 6),
(61, 61, 7),
(62, 62, 7),
(63, 63, 7),
(64, 64, 7),
(65, 65, 7),
(66, 66, 7),
(67, 67, 7),
(68, 68, 7),
(69, 69, 7),
(70, 70, 7),
(71, 71, 8),
(72, 72, 8),
(73, 73, 8),
(74, 74, 8),
(75, 75, 8),
(76, 76, 8),
(77, 77, 8),
(78, 78, 8),
(79, 79, 8),
(80, 80, 8),
(81, 81, 9),
(82, 82, 9),
(83, 83, 9),
(84, 84, 9),
(85, 85, 9),
(86, 86, 9),
(87, 87, 9),
(88, 88, 9),
(89, 89, 9),
(90, 90, 9),
(91, 91, 10),
(92, 92, 10),
(93, 93, 10),
(94, 94, 10),
(95, 95, 10),
(96, 96, 10),
(97, 97, 10),
(98, 98, 10),
(99, 99, 10),
(100, 100, 10),
(101, 101, 11),
(102, 102, 11),
(103, 103, 11),
(104, 104, 11),
(105, 105, 11),
(106, 106, 11),
(107, 107, 11),
(108, 108, 11),
(109, 109, 11),
(110, 110, 11),
(111, 111, 12),
(112, 112, 12),
(113, 113, 12),
(114, 114, 12),
(115, 115, 12),
(116, 116, 12),
(117, 117, 12),
(118, 118, 12),
(119, 119, 12),
(120, 120, 12),
(121, 121, 13),
(122, 122, 13),
(123, 123, 13),
(124, 124, 13),
(125, 125, 13),
(126, 126, 13),
(127, 127, 13),
(128, 128, 13),
(129, 129, 13),
(130, 130, 13),
(131, 131, 14),
(132, 132, 14),
(133, 133, 14),
(134, 134, 14),
(135, 135, 14),
(136, 136, 14),
(137, 137, 14),
(138, 138, 14),
(139, 139, 14),
(140, 140, 14),
(141, 141, 15),
(142, 142, 15),
(143, 143, 15),
(144, 144, 15),
(145, 145, 15),
(146, 146, 15),
(147, 147, 15),
(148, 148, 15),
(149, 149, 15),
(150, 150, 15),
(151, 151, 16),
(152, 152, 16),
(153, 153, 16),
(154, 154, 16),
(155, 155, 16),
(156, 156, 16),
(157, 157, 16),
(158, 158, 16),
(159, 159, 16),
(160, 160, 16),
(161, 161, 17),
(162, 162, 17),
(163, 163, 17),
(164, 164, 17),
(165, 165, 17),
(166, 166, 17),
(167, 167, 17),
(168, 168, 17),
(169, 169, 17),
(170, 170, 17),
(171, 171, 18),
(172, 172, 18),
(173, 173, 18),
(174, 174, 18),
(175, 175, 18),
(176, 176, 18),
(177, 177, 18),
(178, 178, 18),
(179, 179, 18),
(180, 180, 18),
(181, 181, 19),
(182, 182, 19),
(183, 183, 19),
(184, 184, 19),
(185, 185, 19),
(186, 186, 19),
(187, 187, 19),
(188, 188, 19),
(189, 189, 19),
(190, 190, 19),
(191, 191, 20),
(192, 192, 20),
(193, 193, 20),
(194, 194, 20),
(195, 195, 20),
(196, 196, 20),
(197, 197, 20),
(198, 198, 20),
(199, 199, 20),
(200, 200, 20),
(201, 201, 21),
(202, 202, 21),
(203, 203, 21),
(204, 204, 21),
(205, 205, 21),
(206, 206, 21),
(207, 207, 21),
(208, 208, 21),
(209, 209, 21),
(210, 210, 21),
(211, 211, 22),
(212, 212, 22),
(213, 213, 22),
(214, 214, 22),
(215, 215, 22),
(216, 216, 22),
(217, 217, 22),
(218, 218, 22),
(219, 219, 22),
(220, 220, 22),
(221, 221, 23),
(222, 222, 23),
(223, 223, 23),
(224, 224, 23),
(225, 225, 23),
(226, 226, 23),
(227, 227, 23),
(228, 228, 23),
(229, 229, 23),
(230, 230, 23),
(231, 231, 24),
(232, 232, 24),
(233, 233, 24),
(234, 234, 24),
(235, 235, 24),
(236, 236, 24),
(237, 237, 24),
(238, 238, 24),
(239, 239, 24),
(240, 240, 24),
(241, 241, 25),
(242, 242, 25),
(243, 243, 25),
(244, 244, 25),
(245, 245, 25),
(246, 246, 25),
(247, 247, 25),
(248, 248, 25),
(249, 249, 25),
(250, 250, 25),
(251, 251, 26),
(252, 252, 26),
(253, 253, 26),
(254, 254, 26),
(255, 255, 26),
(256, 256, 26),
(257, 257, 26),
(258, 258, 26),
(259, 259, 26),
(260, 260, 26),
(261, 261, 27),
(262, 262, 27),
(263, 263, 27),
(264, 264, 27),
(265, 265, 27),
(266, 266, 27),
(267, 267, 27),
(268, 268, 27),
(269, 269, 27),
(270, 270, 27),
(271, 271, 28),
(272, 272, 28),
(273, 273, 28),
(274, 274, 28),
(275, 275, 28),
(276, 276, 28),
(277, 277, 28),
(278, 278, 28),
(279, 279, 28),
(280, 280, 28),
(281, 281, 29),
(282, 282, 29),
(283, 283, 29),
(284, 284, 29),
(285, 285, 29),
(286, 286, 29),
(287, 287, 29),
(288, 288, 29),
(289, 289, 29),
(290, 290, 29),
(291, 291, 30),
(292, 292, 30),
(293, 293, 30),
(294, 294, 30),
(295, 295, 30),
(296, 296, 30),
(297, 297, 30),
(298, 298, 30),
(299, 299, 30),
(300, 300, 30),
(301, 301, 31),
(302, 302, 31),
(303, 303, 31),
(304, 304, 31),
(305, 305, 31),
(306, 306, 31),
(307, 307, 31),
(308, 308, 31),
(309, 309, 31),
(310, 310, 31),
(311, 311, 32),
(312, 312, 32),
(313, 313, 32),
(314, 314, 32),
(315, 315, 32),
(316, 316, 32),
(317, 317, 32),
(318, 318, 32),
(319, 319, 32),
(320, 320, 32),
(321, 321, 33),
(322, 322, 33),
(323, 323, 33),
(324, 324, 33),
(325, 325, 33),
(326, 326, 33),
(327, 327, 33),
(328, 328, 33),
(329, 329, 33),
(330, 330, 33),
(331, 331, 34),
(332, 332, 34),
(333, 333, 34),
(334, 334, 34),
(335, 335, 34),
(336, 336, 34),
(337, 337, 34),
(338, 338, 34),
(339, 339, 34),
(340, 340, 34),
(341, 341, 35),
(342, 342, 35),
(343, 343, 35),
(344, 344, 35),
(345, 345, 35),
(346, 346, 35),
(347, 347, 35),
(348, 348, 35),
(349, 349, 35),
(350, 350, 35),
(351, 351, 36),
(352, 352, 36),
(353, 353, 36),
(354, 354, 36),
(355, 355, 36),
(356, 356, 36),
(357, 357, 36),
(358, 358, 36),
(359, 359, 36),
(360, 360, 36),
(361, 361, 37),
(362, 362, 37),
(363, 363, 37),
(364, 364, 37),
(365, 365, 37),
(366, 366, 37),
(367, 367, 37),
(368, 368, 37),
(369, 369, 37),
(370, 370, 37),
(371, 371, 38),
(372, 372, 38),
(373, 373, 38),
(374, 374, 38),
(375, 375, 38),
(376, 376, 38),
(377, 377, 38),
(378, 378, 38),
(379, 379, 38),
(380, 380, 38),
(381, 381, 39),
(382, 382, 39),
(383, 383, 39),
(384, 384, 39),
(385, 385, 39),
(386, 386, 39),
(387, 387, 39),
(388, 388, 39),
(389, 389, 39),
(390, 390, 39),
(391, 391, 40),
(392, 392, 40),
(393, 393, 40),
(394, 394, 40),
(395, 395, 40),
(396, 396, 40),
(397, 397, 40),
(398, 398, 40),
(399, 399, 40),
(400, 400, 40),
(401, 401, 41),
(402, 402, 41),
(403, 403, 41),
(404, 404, 41),
(405, 405, 41),
(406, 406, 41),
(407, 407, 41),
(408, 408, 41),
(409, 409, 41),
(410, 410, 41),
(411, 411, 42),
(412, 412, 42),
(413, 413, 42),
(414, 414, 42),
(415, 415, 42),
(416, 416, 42),
(417, 417, 42),
(418, 418, 42),
(419, 419, 42),
(420, 420, 42),
(421, 421, 43),
(422, 422, 43),
(423, 423, 43),
(424, 424, 43),
(425, 425, 43),
(426, 426, 43),
(427, 427, 43),
(428, 428, 43),
(429, 429, 43),
(430, 430, 43),
(431, 431, 44),
(432, 432, 44),
(433, 433, 44),
(434, 434, 44),
(435, 435, 44),
(436, 436, 44),
(437, 437, 44),
(438, 438, 44),
(439, 439, 44),
(440, 440, 44),
(441, 441, 45),
(442, 442, 45),
(443, 443, 45),
(444, 444, 45),
(445, 445, 45),
(446, 446, 45),
(447, 447, 45),
(448, 448, 45),
(449, 449, 45),
(450, 450, 45),
(451, 451, 46),
(452, 452, 46),
(453, 453, 46),
(454, 454, 46),
(455, 455, 46),
(456, 456, 46),
(457, 457, 46),
(458, 458, 46),
(459, 459, 46),
(460, 460, 46),
(461, 461, 47),
(462, 462, 47),
(463, 463, 47),
(464, 464, 47),
(465, 465, 47),
(466, 466, 47),
(467, 467, 47),
(468, 468, 47),
(469, 469, 47),
(470, 470, 47),
(471, 471, 48),
(472, 472, 48),
(473, 473, 48),
(474, 474, 48),
(475, 475, 48),
(476, 476, 48),
(477, 477, 48),
(478, 478, 48),
(479, 479, 48),
(480, 480, 48),
(481, 481, 49),
(482, 482, 49),
(483, 483, 49),
(484, 484, 49),
(485, 485, 49),
(486, 486, 49),
(487, 487, 49),
(488, 488, 49),
(489, 489, 49),
(490, 490, 49),
(491, 491, 50),
(492, 492, 50),
(493, 493, 50),
(494, 494, 50),
(495, 495, 50),
(496, 496, 50),
(497, 497, 50),
(498, 498, 50),
(499, 499, 50),
(500, 500, 50),
(501, 501, 51),
(502, 502, 51),
(503, 503, 51),
(504, 504, 51),
(505, 505, 51),
(506, 506, 51),
(507, 507, 51),
(508, 508, 51),
(509, 509, 51),
(510, 510, 51),
(511, 511, 52),
(512, 512, 52),
(513, 513, 52),
(514, 514, 52),
(515, 515, 52),
(516, 516, 52),
(517, 517, 52),
(518, 518, 52),
(519, 519, 52),
(520, 520, 52),
(521, 521, 53),
(522, 522, 53),
(523, 523, 53),
(524, 524, 53),
(525, 525, 53),
(526, 526, 53),
(527, 527, 53),
(528, 528, 53),
(529, 529, 53),
(530, 530, 53),
(531, 531, 54),
(532, 532, 54),
(533, 533, 54),
(534, 534, 54),
(535, 535, 54),
(536, 536, 54),
(537, 537, 54),
(538, 538, 54),
(539, 539, 54),
(540, 540, 54),
(541, 541, 55),
(542, 542, 55),
(543, 543, 55),
(544, 544, 55),
(545, 545, 55),
(546, 546, 55),
(547, 547, 55),
(548, 548, 55),
(549, 549, 55),
(550, 550, 55),
(551, 551, 56),
(552, 552, 56),
(553, 553, 56),
(554, 554, 56),
(555, 555, 56),
(556, 556, 56),
(557, 557, 56),
(558, 558, 56),
(559, 559, 56),
(560, 560, 56),
(561, 561, 57),
(562, 562, 57),
(563, 563, 57),
(564, 564, 57),
(565, 565, 57),
(566, 566, 57),
(567, 567, 57),
(568, 568, 57),
(569, 569, 57),
(570, 570, 57),
(571, 571, 58),
(572, 572, 58),
(573, 573, 58),
(574, 574, 58),
(575, 575, 58),
(576, 576, 58),
(577, 577, 58),
(578, 578, 58),
(579, 579, 58),
(580, 580, 58),
(581, 581, 59),
(582, 582, 59),
(583, 583, 59),
(584, 584, 59),
(585, 585, 59),
(586, 586, 59),
(587, 587, 59),
(588, 588, 59),
(589, 589, 59),
(590, 590, 59),
(591, 591, 60),
(592, 592, 60),
(593, 593, 60),
(594, 594, 60),
(595, 595, 60),
(596, 596, 60),
(597, 597, 60),
(598, 598, 60),
(599, 599, 60),
(600, 600, 60),
(601, 601, 61),
(602, 602, 61),
(603, 603, 61),
(604, 604, 61),
(605, 605, 61),
(606, 606, 61),
(607, 607, 61),
(608, 608, 61),
(609, 609, 61),
(610, 610, 61),
(611, 611, 62),
(612, 612, 62),
(613, 613, 62),
(614, 614, 62),
(615, 615, 62),
(616, 616, 62),
(617, 617, 62),
(618, 618, 62),
(619, 619, 62),
(620, 620, 62),
(621, 621, 63),
(622, 622, 63),
(623, 623, 63),
(624, 624, 63),
(625, 625, 63),
(626, 626, 63),
(627, 627, 63),
(628, 628, 63),
(629, 629, 63),
(630, 630, 63),
(631, 631, 64),
(632, 632, 64),
(633, 633, 64),
(634, 634, 64),
(635, 635, 64),
(636, 636, 64),
(637, 637, 64),
(638, 638, 64),
(639, 639, 64),
(640, 640, 64),
(641, 641, 65),
(642, 642, 65),
(643, 643, 65),
(644, 644, 65),
(645, 645, 65),
(646, 646, 65),
(647, 647, 65),
(648, 648, 65),
(649, 649, 65),
(650, 650, 65),
(651, 651, 66),
(652, 652, 66),
(653, 653, 66),
(654, 654, 66),
(655, 655, 66),
(656, 656, 66),
(657, 657, 66),
(658, 658, 66),
(659, 659, 66),
(660, 660, 66),
(661, 661, 67),
(662, 662, 67),
(663, 663, 67),
(664, 664, 67),
(665, 665, 67),
(666, 666, 67),
(667, 667, 67),
(668, 668, 67),
(669, 669, 67),
(670, 670, 67),
(671, 671, 68),
(672, 672, 68),
(673, 673, 68),
(674, 674, 68),
(675, 675, 68),
(676, 676, 68),
(677, 677, 68),
(678, 678, 68),
(679, 679, 68),
(680, 680, 68),
(681, 681, 69),
(682, 682, 69),
(683, 683, 69),
(684, 684, 69),
(685, 685, 69),
(686, 686, 69),
(687, 687, 69),
(688, 688, 69),
(689, 689, 69),
(690, 690, 69),
(691, 691, 70),
(692, 692, 70),
(693, 693, 70),
(694, 694, 70),
(695, 695, 70),
(696, 696, 70),
(697, 697, 70),
(698, 698, 70),
(699, 699, 70),
(700, 700, 70);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `logusuarios`
--

CREATE TABLE IF NOT EXISTS `logusuarios` (
  `idUsuario` int(11) NOT NULL AUTO_INCREMENT,
  `FechaLog` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `idAccion` int(11) NOT NULL,
  PRIMARY KEY (`idUsuario`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tarjeta`
--

CREATE TABLE IF NOT EXISTS `tarjeta` (
  `idTarjeta` int(11) NOT NULL AUTO_INCREMENT,
  `idDeptoTarjeta` int(11) NOT NULL,
  `CodigoTarjeta` varchar(10) NOT NULL,
  `NombrePersonaTarjeta` varchar(250) NOT NULL,
  PRIMARY KEY (`idTarjeta`),
  KEY `idDeptoTarjeta` (`idDeptoTarjeta`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=701 ;

--
-- Volcado de datos para la tabla `tarjeta`
--

INSERT INTO `tarjeta` (`idTarjeta`, `idDeptoTarjeta`, `CodigoTarjeta`, `NombrePersonaTarjeta`) VALUES
(1, 1, '', ''),
(2, 2, '', ''),
(3, 3, '', ''),
(4, 4, '', ''),
(5, 5, '', ''),
(6, 6, '', ''),
(7, 7, '', ''),
(8, 8, '', ''),
(9, 9, '', ''),
(10, 10, '', ''),
(11, 11, '', ''),
(12, 12, '', ''),
(13, 13, '', ''),
(14, 14, '', ''),
(15, 15, '', ''),
(16, 16, '', ''),
(17, 17, '', ''),
(18, 18, '', ''),
(19, 19, '', ''),
(20, 20, '', ''),
(21, 21, '', ''),
(22, 22, '', ''),
(23, 23, '', ''),
(24, 24, '', ''),
(25, 25, '', ''),
(26, 26, '', ''),
(27, 27, '', ''),
(28, 28, '', ''),
(29, 29, '', ''),
(30, 30, '', ''),
(31, 31, '', ''),
(32, 32, '', ''),
(33, 33, '', ''),
(34, 34, '', ''),
(35, 35, '', ''),
(36, 36, '', ''),
(37, 37, '', ''),
(38, 38, '', ''),
(39, 39, '', ''),
(40, 40, '', ''),
(41, 41, '', ''),
(42, 42, '', ''),
(43, 43, '', ''),
(44, 44, '', ''),
(45, 45, '', ''),
(46, 46, '', ''),
(47, 47, '', ''),
(48, 48, '', ''),
(49, 49, '', ''),
(50, 50, '', ''),
(51, 51, '', ''),
(52, 52, '', ''),
(53, 53, '', ''),
(54, 54, '', ''),
(55, 55, '', ''),
(56, 56, '', ''),
(57, 57, '', ''),
(58, 58, '', ''),
(59, 59, '', ''),
(60, 60, '', ''),
(61, 61, '', ''),
(62, 62, '', ''),
(63, 63, '', ''),
(64, 64, '', ''),
(65, 65, '', ''),
(66, 66, '', ''),
(67, 67, '', ''),
(68, 68, '', ''),
(69, 69, '', ''),
(70, 70, '', ''),
(71, 71, '', ''),
(72, 72, '', ''),
(73, 73, '', ''),
(74, 74, '', ''),
(75, 75, '', ''),
(76, 76, '', ''),
(77, 77, '', ''),
(78, 78, '', ''),
(79, 79, '', ''),
(80, 80, '', ''),
(81, 81, '', ''),
(82, 82, '', ''),
(83, 83, '', ''),
(84, 84, '', ''),
(85, 85, '', ''),
(86, 86, '', ''),
(87, 87, '', ''),
(88, 88, '', ''),
(89, 89, '', ''),
(90, 90, '', ''),
(91, 91, '', ''),
(92, 92, '', ''),
(93, 93, '', ''),
(94, 94, '', ''),
(95, 95, '', ''),
(96, 96, '', ''),
(97, 97, '', ''),
(98, 98, '', ''),
(99, 99, '', ''),
(100, 100, '', ''),
(101, 101, '', ''),
(102, 102, '', ''),
(103, 103, '', ''),
(104, 104, '', ''),
(105, 105, '', ''),
(106, 106, '', ''),
(107, 107, '', ''),
(108, 108, '', ''),
(109, 109, '', ''),
(110, 110, '', ''),
(111, 111, '', ''),
(112, 112, '', ''),
(113, 113, '', ''),
(114, 114, '', ''),
(115, 115, '', ''),
(116, 116, '', ''),
(117, 117, '', ''),
(118, 118, '', ''),
(119, 119, '', ''),
(120, 120, '', ''),
(121, 121, '', ''),
(122, 122, '', ''),
(123, 123, '', ''),
(124, 124, '', ''),
(125, 125, '', ''),
(126, 126, '', ''),
(127, 127, '', ''),
(128, 128, '', ''),
(129, 129, '', ''),
(130, 130, '', ''),
(131, 131, '', ''),
(132, 132, '', ''),
(133, 133, '', ''),
(134, 134, '', ''),
(135, 135, '', ''),
(136, 136, '', ''),
(137, 137, '', ''),
(138, 138, '', ''),
(139, 139, '', ''),
(140, 140, '', ''),
(141, 141, '', ''),
(142, 142, '', ''),
(143, 143, '', ''),
(144, 144, '', ''),
(145, 145, '', ''),
(146, 146, '', ''),
(147, 147, '', ''),
(148, 148, '', ''),
(149, 149, '', ''),
(150, 150, '', ''),
(151, 151, '', ''),
(152, 152, '', ''),
(153, 153, '', ''),
(154, 154, '', ''),
(155, 155, '', ''),
(156, 156, '', ''),
(157, 157, '', ''),
(158, 158, '', ''),
(159, 159, '', ''),
(160, 160, '', ''),
(161, 161, '', ''),
(162, 162, '', ''),
(163, 163, '', ''),
(164, 164, '', ''),
(165, 165, '', ''),
(166, 166, '', ''),
(167, 167, '', ''),
(168, 168, '', ''),
(169, 169, '', ''),
(170, 170, '', ''),
(171, 171, '', ''),
(172, 172, '', ''),
(173, 173, '', ''),
(174, 174, '', ''),
(175, 175, '', ''),
(176, 176, '', ''),
(177, 177, '', ''),
(178, 178, '', ''),
(179, 179, '', ''),
(180, 180, '', ''),
(181, 181, '', ''),
(182, 182, '', ''),
(183, 183, '', ''),
(184, 184, '', ''),
(185, 185, '', ''),
(186, 186, '', ''),
(187, 187, '', ''),
(188, 188, '', ''),
(189, 189, '', ''),
(190, 190, '', ''),
(191, 191, '', ''),
(192, 192, '', ''),
(193, 193, '', ''),
(194, 194, '', ''),
(195, 195, '', ''),
(196, 196, '', ''),
(197, 197, '', ''),
(198, 198, '', ''),
(199, 199, '', ''),
(200, 200, '', ''),
(201, 201, '', ''),
(202, 202, '', ''),
(203, 203, '', ''),
(204, 204, '', ''),
(205, 205, '', ''),
(206, 206, '', ''),
(207, 207, '', ''),
(208, 208, '', ''),
(209, 209, '', ''),
(210, 210, '', ''),
(211, 211, '', ''),
(212, 212, '', ''),
(213, 213, '', ''),
(214, 214, '', ''),
(215, 215, '', ''),
(216, 216, '', ''),
(217, 217, '', ''),
(218, 218, '', ''),
(219, 219, '', ''),
(220, 220, '', ''),
(221, 221, '', ''),
(222, 222, '', ''),
(223, 223, '', ''),
(224, 224, '', ''),
(225, 225, '', ''),
(226, 226, '', ''),
(227, 227, '', ''),
(228, 228, '', ''),
(229, 229, '', ''),
(230, 230, '', ''),
(231, 231, '', ''),
(232, 232, '', ''),
(233, 233, '', ''),
(234, 234, '', ''),
(235, 235, '', ''),
(236, 236, '', ''),
(237, 237, '', ''),
(238, 238, '', ''),
(239, 239, '', ''),
(240, 240, '', ''),
(241, 241, '', ''),
(242, 242, '', ''),
(243, 243, '', ''),
(244, 244, '', ''),
(245, 245, '', ''),
(246, 246, '', ''),
(247, 247, '', ''),
(248, 248, '', ''),
(249, 249, '', ''),
(250, 250, '', ''),
(251, 251, '', ''),
(252, 252, '', ''),
(253, 253, '', ''),
(254, 254, '', ''),
(255, 255, '', ''),
(256, 256, '', ''),
(257, 257, '', ''),
(258, 258, '', ''),
(259, 259, '', ''),
(260, 260, '', ''),
(261, 261, '', ''),
(262, 262, '', ''),
(263, 263, '', ''),
(264, 264, '', ''),
(265, 265, '', ''),
(266, 266, '', ''),
(267, 267, '', ''),
(268, 268, '', ''),
(269, 269, '', ''),
(270, 270, '', ''),
(271, 271, '', ''),
(272, 272, '', ''),
(273, 273, '', ''),
(274, 274, '', ''),
(275, 275, '', ''),
(276, 276, '', ''),
(277, 277, '', ''),
(278, 278, '', ''),
(279, 279, '', ''),
(280, 280, '', ''),
(281, 281, '', ''),
(282, 282, '', ''),
(283, 283, '', ''),
(284, 284, '', ''),
(285, 285, '', ''),
(286, 286, '', ''),
(287, 287, '', ''),
(288, 288, '', ''),
(289, 289, '', ''),
(290, 290, '', ''),
(291, 291, '', ''),
(292, 292, '', ''),
(293, 293, '', ''),
(294, 294, '', ''),
(295, 295, '', ''),
(296, 296, '', ''),
(297, 297, '', ''),
(298, 298, '', ''),
(299, 299, '', ''),
(300, 300, '', ''),
(301, 301, '', ''),
(302, 302, '', ''),
(303, 303, '', ''),
(304, 304, '', ''),
(305, 305, '', ''),
(306, 306, '', ''),
(307, 307, '', ''),
(308, 308, '', ''),
(309, 309, '', ''),
(310, 310, '', ''),
(311, 311, '', ''),
(312, 312, '', ''),
(313, 313, '', ''),
(314, 314, '', ''),
(315, 315, '', ''),
(316, 316, '', ''),
(317, 317, '', ''),
(318, 318, '', ''),
(319, 319, '', ''),
(320, 320, '', ''),
(321, 321, '', ''),
(322, 322, '', ''),
(323, 323, '', ''),
(324, 324, '', ''),
(325, 325, '', ''),
(326, 326, '', ''),
(327, 327, '', ''),
(328, 328, '', ''),
(329, 329, '', ''),
(330, 330, '', ''),
(331, 331, '', ''),
(332, 332, '', ''),
(333, 333, '', ''),
(334, 334, '', ''),
(335, 335, '', ''),
(336, 336, '', ''),
(337, 337, '', ''),
(338, 338, '', ''),
(339, 339, '', ''),
(340, 340, '', ''),
(341, 341, '', ''),
(342, 342, '', ''),
(343, 343, '', ''),
(344, 344, '', ''),
(345, 345, '', ''),
(346, 346, '', ''),
(347, 347, '', ''),
(348, 348, '', ''),
(349, 349, '', ''),
(350, 350, '', ''),
(351, 351, '', ''),
(352, 352, '', ''),
(353, 353, '', ''),
(354, 354, '', ''),
(355, 355, '', ''),
(356, 356, '', ''),
(357, 357, '', ''),
(358, 358, '', ''),
(359, 359, '', ''),
(360, 360, '', ''),
(361, 361, '', ''),
(362, 362, '', ''),
(363, 363, '', ''),
(364, 364, '', ''),
(365, 365, '', ''),
(366, 366, '', ''),
(367, 367, '', ''),
(368, 368, '', ''),
(369, 369, '', ''),
(370, 370, '', ''),
(371, 371, '', ''),
(372, 372, '', ''),
(373, 373, '', ''),
(374, 374, '', ''),
(375, 375, '', ''),
(376, 376, '', ''),
(377, 377, '', ''),
(378, 378, '', ''),
(379, 379, '', ''),
(380, 380, '', ''),
(381, 381, '', ''),
(382, 382, '', ''),
(383, 383, '', ''),
(384, 384, '', ''),
(385, 385, '', ''),
(386, 386, '', ''),
(387, 387, '', ''),
(388, 388, '', ''),
(389, 389, '', ''),
(390, 390, '', ''),
(391, 391, '', ''),
(392, 392, '', ''),
(393, 393, '', ''),
(394, 394, '', ''),
(395, 395, '', ''),
(396, 396, '', ''),
(397, 397, '', ''),
(398, 398, '', ''),
(399, 399, '', ''),
(400, 400, '', ''),
(401, 401, '', ''),
(402, 402, '', ''),
(403, 403, '', ''),
(404, 404, '', ''),
(405, 405, '', ''),
(406, 406, '', ''),
(407, 407, '', ''),
(408, 408, '', ''),
(409, 409, '', ''),
(410, 410, '', ''),
(411, 411, '', ''),
(412, 412, '', ''),
(413, 413, '', ''),
(414, 414, '', ''),
(415, 415, '', ''),
(416, 416, '', ''),
(417, 417, '', ''),
(418, 418, '', ''),
(419, 419, '', ''),
(420, 420, '', ''),
(421, 421, '', ''),
(422, 422, '', ''),
(423, 423, '', ''),
(424, 424, '', ''),
(425, 425, '', ''),
(426, 426, '', ''),
(427, 427, '', ''),
(428, 428, '', ''),
(429, 429, '', ''),
(430, 430, '', ''),
(431, 431, '', ''),
(432, 432, '', ''),
(433, 433, '', ''),
(434, 434, '', ''),
(435, 435, '', ''),
(436, 436, '', ''),
(437, 437, '', ''),
(438, 438, '', ''),
(439, 439, '', ''),
(440, 440, '', ''),
(441, 441, '', ''),
(442, 442, '', ''),
(443, 443, '', ''),
(444, 444, '', ''),
(445, 445, '', ''),
(446, 446, '', ''),
(447, 447, '', ''),
(448, 448, '', ''),
(449, 449, '', ''),
(450, 450, '', ''),
(451, 451, '', ''),
(452, 452, '', ''),
(453, 453, '', ''),
(454, 454, '', ''),
(455, 455, '', ''),
(456, 456, '', ''),
(457, 457, '', ''),
(458, 458, '', ''),
(459, 459, '', ''),
(460, 460, '', ''),
(461, 461, '', ''),
(462, 462, '', ''),
(463, 463, '', ''),
(464, 464, '', ''),
(465, 465, '', ''),
(466, 466, '', ''),
(467, 467, '', ''),
(468, 468, '', ''),
(469, 469, '', ''),
(470, 470, '', ''),
(471, 471, '', ''),
(472, 472, '', ''),
(473, 473, '', ''),
(474, 474, '', ''),
(475, 475, '', ''),
(476, 476, '', ''),
(477, 477, '', ''),
(478, 478, '', ''),
(479, 479, '', ''),
(480, 480, '', ''),
(481, 481, '', ''),
(482, 482, '', ''),
(483, 483, '', ''),
(484, 484, '', ''),
(485, 485, '', ''),
(486, 486, '', ''),
(487, 487, '', ''),
(488, 488, '', ''),
(489, 489, '', ''),
(490, 490, '', ''),
(491, 491, '', ''),
(492, 492, '', ''),
(493, 493, '', ''),
(494, 494, '', ''),
(495, 495, '', ''),
(496, 496, '', ''),
(497, 497, '', ''),
(498, 498, '', ''),
(499, 499, '', ''),
(500, 500, '', ''),
(501, 501, '', ''),
(502, 502, '', ''),
(503, 503, '', ''),
(504, 504, '', ''),
(505, 505, '', ''),
(506, 506, '', ''),
(507, 507, '', ''),
(508, 508, '', ''),
(509, 509, '', ''),
(510, 510, '', ''),
(511, 511, '', ''),
(512, 512, '', ''),
(513, 513, '', ''),
(514, 514, '', ''),
(515, 515, '', ''),
(516, 516, '', ''),
(517, 517, '', ''),
(518, 518, '', ''),
(519, 519, '', ''),
(520, 520, '', ''),
(521, 521, '', ''),
(522, 522, '', ''),
(523, 523, '', ''),
(524, 524, '', ''),
(525, 525, '', ''),
(526, 526, '', ''),
(527, 527, '', ''),
(528, 528, '', ''),
(529, 529, '', ''),
(530, 530, '', ''),
(531, 531, '', ''),
(532, 532, '', ''),
(533, 533, '', ''),
(534, 534, '', ''),
(535, 535, '', ''),
(536, 536, '', ''),
(537, 537, '', ''),
(538, 538, '', ''),
(539, 539, '', ''),
(540, 540, '', ''),
(541, 541, '', ''),
(542, 542, '', ''),
(543, 543, '', ''),
(544, 544, '', ''),
(545, 545, '', ''),
(546, 546, '', ''),
(547, 547, '', ''),
(548, 548, '', ''),
(549, 549, '', ''),
(550, 550, '', ''),
(551, 551, '', ''),
(552, 552, '', ''),
(553, 553, '', ''),
(554, 554, '', ''),
(555, 555, '', ''),
(556, 556, '', ''),
(557, 557, '', ''),
(558, 558, '', ''),
(559, 559, '', ''),
(560, 560, '', ''),
(561, 561, '', ''),
(562, 562, '', ''),
(563, 563, '', ''),
(564, 564, '', ''),
(565, 565, '', ''),
(566, 566, '', ''),
(567, 567, '', ''),
(568, 568, '', ''),
(569, 569, '', ''),
(570, 570, '', ''),
(571, 571, '', ''),
(572, 572, '', ''),
(573, 573, '', ''),
(574, 574, '', ''),
(575, 575, '', ''),
(576, 576, '', ''),
(577, 577, '', ''),
(578, 578, '', ''),
(579, 579, '', ''),
(580, 580, '', ''),
(581, 581, '', ''),
(582, 582, '', ''),
(583, 583, '', ''),
(584, 584, '', ''),
(585, 585, '', ''),
(586, 586, '', ''),
(587, 587, '', ''),
(588, 588, '', ''),
(589, 589, '', ''),
(590, 590, '', ''),
(591, 591, '', 'Ernesto Dellarosa'),
(592, 592, '', ''),
(593, 593, '', ''),
(594, 594, '', ''),
(595, 595, '', ''),
(596, 596, '', ''),
(597, 597, '', ''),
(598, 598, '', ''),
(599, 599, '', ''),
(600, 600, '', 'Fabio Dellaosa'),
(601, 601, '', ''),
(602, 602, '', ''),
(603, 603, '', ''),
(604, 604, '', ''),
(605, 605, '', ''),
(606, 606, '', ''),
(607, 607, '', ''),
(608, 608, '', ''),
(609, 609, '', ''),
(610, 610, '', ''),
(611, 611, '', ''),
(612, 612, '', ''),
(613, 613, '', ''),
(614, 614, '', ''),
(615, 615, '', ''),
(616, 616, '', ''),
(617, 617, '', ''),
(618, 618, '', ''),
(619, 619, '', ''),
(620, 620, '', ''),
(621, 621, '', ''),
(622, 622, '', ''),
(623, 623, '', ''),
(624, 624, '', ''),
(625, 625, '', ''),
(626, 626, '', ''),
(627, 627, '', ''),
(628, 628, '', ''),
(629, 629, '', ''),
(630, 630, '', ''),
(631, 631, '', ''),
(632, 632, '', ''),
(633, 633, '', ''),
(634, 634, '', ''),
(635, 635, '', ''),
(636, 636, '', ''),
(637, 637, '', ''),
(638, 638, '', ''),
(639, 639, '', ''),
(640, 640, '', ''),
(641, 641, '', ''),
(642, 642, '', ''),
(643, 643, '', ''),
(644, 644, '', ''),
(645, 645, '', ''),
(646, 646, '', ''),
(647, 647, '', ''),
(648, 648, '', ''),
(649, 649, '', ''),
(650, 650, '', ''),
(651, 651, '', ''),
(652, 652, '', ''),
(653, 653, '', ''),
(654, 654, '', ''),
(655, 655, '', ''),
(656, 656, '', ''),
(657, 657, '', ''),
(658, 658, '', ''),
(659, 659, '', ''),
(660, 660, '', ''),
(661, 661, '', ''),
(662, 662, '', ''),
(663, 663, '', ''),
(664, 664, '', ''),
(665, 665, '', ''),
(666, 666, '', ''),
(667, 667, '', ''),
(668, 668, '', ''),
(669, 669, '', ''),
(670, 670, '', ''),
(671, 671, '', ''),
(672, 672, '', ''),
(673, 673, '', ''),
(674, 674, '', ''),
(675, 675, '', ''),
(676, 676, '', ''),
(677, 677, '', ''),
(678, 678, '', ''),
(679, 679, '', ''),
(680, 680, '', ''),
(681, 681, '', ''),
(682, 682, '', ''),
(683, 683, '', ''),
(684, 684, '', ''),
(685, 685, '', ''),
(686, 686, '', ''),
(687, 687, '', ''),
(688, 688, '', ''),
(689, 689, '', ''),
(690, 690, '', ''),
(691, 691, '', ''),
(692, 692, '', ''),
(693, 693, '', ''),
(694, 694, '', ''),
(695, 695, '', ''),
(696, 696, '', ''),
(697, 697, '', ''),
(698, 698, '', ''),
(699, 699, '', ''),
(700, 700, '', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `usuario`
--

CREATE TABLE IF NOT EXISTS `usuario` (
  `idUsuario` int(11) NOT NULL AUTO_INCREMENT,
  `Nombre` varchar(250) NOT NULL,
  `Apellido` varchar(250) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `NumeroDoc` int(8) NOT NULL,
  `Password` varchar(200) NOT NULL,
  `Jerarquia` varchar(30) NOT NULL,
  PRIMARY KEY (`idUsuario`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Volcado de datos para la tabla `usuario`
--

INSERT INTO `usuario` (`idUsuario`, `Nombre`, `Apellido`, `Email`, `NumeroDoc`, `Password`, `Jerarquia`) VALUES
(1, 'Fabio', 'Dellarosa', 'dellarosafabio@gmail.com', 31934220, '3dbe00a167653a1aaee01d93e77e730e', 'Administrador'),
(2, 'Orlando', '', '', 0, '', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
